Complete guide to AI text embeddings in SQL Server, featuring everything you need to know – with tips, advice and examples. Plus: how to install and use Ollama with SQL Server.

Greg Low in SQL Server

Vector search in SQL Server: VECTOR_DISTANCE, VECTOR_SEARCH, and index trade-offs

Learn how to use VECTOR_DISTANCE and VECTOR_SEARCH in SQL Server to find semantically similar data. Covers vector indexes, performance trade-offs,…

17 June 2026 7 min read 1

Greg Low in SQL Server

How to call an Ollama-based AI text embeddings model from SQL Server 2025

Learn how to call locally hosted Ollama embedding models from SQL Server using sp_invoke_external_rest_endpoint, CREATE EXTERNAL MODEL, and AI_GENERATE_EMBEDDINGS.…

08 June 2026 5 min read 11

Greg Low in SQL Server

How to host an AI text embeddings model for SQL Server using Ollama

Learn how to install Ollama locally to generate text embeddings for SQL Server vector search, plus configure a Caddy proxy…

01 June 2026 5 min read 21